﻿CREATE TABLE [dbo].[WhsAddins]
(
	WhsAddinId int identity(1,1) NOT NULL, 
	HslAddinId int NULL,
	UpdatedDate datetimeoffset NULL,
	LastSyncDate datetime NOT NULL default current_timestamp,

	ProductCode uniqueidentifier NOT NULL,
	Author nvarchar(150) NOT NULL,
	Title nvarchar(150) NOT NULL,
	Version varchar(50) NOT NULL,

	HslCategoryId int NULL,
	AuthorUrl varchar(250) NULL,
	ChangeLog ntext NULL,
	ChangeLogUrl varchar(250) NULL,
	DescText ntext NULL,
	DownloadCount int NULL,
	DownloadUrl varchar(250) NULL,
	ForumUrl varchar(250) NULL,
	Rating float NULL,
	ReleaseDate datetimeoffset NULL,
	Requirements ntext NULL,
)
